Managing data for financial instruments

From the Instrument Data Mart page in the Command Center, you can import data for financial instruments, populate and maintain data tables, perform Data Quality Analysis (DQA), and review validation reports.

The following table describes the tasks you can perform on each tab of this page.

Tab Description
Load Data Import records for multiple types of financial instruments.
Staging and Analysis Update the reference tables for specific types of financial instruments.
Manage Tables Update the reference tables for specific types of financial instruments.
Process Data Process profitability data.
View Reports Review validation reports for stored data about financial instruments

Load Data tab

From the Load Data tab, you can import records for one or more types of financial instruments, such as certificates of deposit (CDs) or loans. Each row of the table under Import Instrument Records represents a type of financial instrument.

TIP: You can also select the import files to be loaded using the import settings selected on the Load Data tab of the System Administration page. For more information, see Loading system data.

The table on this page contains the following columns.

Column Description
[no heading] A check box indicating whether each type of record is selected for import.
Description A text description assigned to each import file.
Import table The table associated with the type of financial instrument contained in the import files, such as loans, deposits, or credit cards.
Import utility The utility associated with the import file in the Relationship Profitability and Pricing System (RPPS).
Start Period The start date of the period for which to import data.
End Period The end date of the period for which to import data.
Process A button to initiate processing of each import. When no file is selected, the button is inactive.
Saved On The most recent date when each type of import was processed.
Import status A message indicating the status of the most recent import: In Progress, Unable to Process, or Completed.

To import records for financial instruments:

  1. From the Command Center, click Instrument Data Mart.

  2. Click Load Data.

  3. In the Import File column for each type of instrument data to be imported, select a file from the list.

  4. In the Start Period column, click the calendar icon and select a start date from the calendar grid.

  5. In the End Period column, click the calendar icon and select an end date from the calendar grid.

  6. In the Process column for the selected file, click Process.

TIP: To process multiple imports, select the check box for each import, then click Process Selection.

Staging and Analysis tab

From the Staging and Analysis tab, you can copy financial instrument data to the staging table before processing of Data Quality Analysis (DQA).

NOTE: The staging table is the source for processing of Funds Transfer Pricing (FTP) and for the cash flow data generated for planning.

This tab includes the following sub-tabs:

  • Populate Staging Table

  • DQA Settings

TIP: For more information, see Instrument data staging and DQA.

Manage Tables tab

From the Manage Tables tab, you can update the reference tables for specific types of financial instruments.

The following tables can be updated from this tab.

Reference Table Example
Interest Index Map

Click to enlarge image
Treasury Import Map

Click to enlarge image
Product

Click to enlarge image
Interest Index

Click to enlarge image
Default Interest Index

Click to enlarge image

Updating Interest Index Map, Treasure Import Map, Product, and Interest Index tables

To update reference tables for financial instruments: 

  1. From the Command Center, click Instrument Data Mart.

  2. Click Manage Tables.

  3. Under Manage Instrument Reference Tables, click Open in the Action column for the table you want to update.

    NOTE: The table opens in a separate browser tab.

  4. Update the table as needed, using the following display and edit options.

    • To sort or filter the page display by the content of any column in the table, click the down arrow to the right of the column heading and select any of the sorting or filtering options in the control panel, then click Apply.

    • To add a blank row at the bottom of the table, click Add Row.

    • To add multiple rows:

      • Click Add Rows.

      • In the Add Rows dialog, click the arrows to select the number of rows to add.

      • Click OK.

    • To delete a row:

      • Select the row, then click Delete Row.

      • In the Confirm Delete dialog, click OK.

    • To save all changes, click Save.

Updating the Default Interest Index table

The Default Interest Index page allows you to set up default interest indexes for your products. This process is different than the one noted above for the other reference tables.

To update the default interest index for a single product:

  1. From the Command Center, click Instrument Data Mart.
  2. Click Manage Tables.

  3. Under Manage Instrument Reference Tables, click Open in the Default interest index row.

    Click to enlarge image

  4. Select a new value in the Default Interest Index column for the product.

    NOTE: You can filter products using the Filter icon in the Interest type column, or search for products using the search box at the top of the page.

  5. [Optional] Select the Allow users to override pricing index (RPPS) check box.
  6. Click Save.
  7. Click OK at the prompt.

To update the default interest index for multiple products:

  1. From the Command Center, click Instrument Data Mart.

  2. Click Manage Tables.

  3. Under Manage Instrument Reference Tables, click Open in the Default Interest Index row.

    TIP: Use the filter and search features to limit the number of products returned.

  4. Select the check boxes for each product you want to update. You can select all products by selecting the check box in the header row.

  5. Click the Edit button.

  6. In the Edit dialog box, select an interest index in the Map to interest index drop-down list. This will apply to all products selected.

    Click to enlarge image

    NOTE: If you do not select a default index in the Edit dialog, the index already assigned will be maintained.

  7. Select or clear the Allow users to override pricing index (RPPS) check box. This setting

  8. Click Edit.

  9. Click OK at the prompt.

Process Data tab

The Process Data tab allows you to process your capital allocations directly from the Instrument Data Mart page.

To process profitability data:

  1. From the Command Center, click Instrument Data Mart.
  2. Click Process Data.

  3. Specify the period for which you want to process capital allocations in the Processing period field.

    TIP: You can type a month and year in the field (MM YYYY) or click the calendar icon to select a month and year.

  4. Select the capital allocations you want to process in the Name column.

  5. Click Process. The Process status column will be updated when processing is complete. Following is a list of all statuses:

    • Pending – job has not been run yet
    • In progress – the job is running

    • Completed - the job completed successfully

    • Unable to process – the job cannot be started

    • Completed with errors – the job completed with errors

View Reports tab

From the View Reports tab, you can review validation reports for stored data about financial instruments.

TIP: View each report after processing DQA.

The following reports are currently available for viewing, along with any reports that may be added by the client organization.

Report Example
DQA Log Drill - RPPS

This report lists DQA log entries from Axiom RPPS.

Click to enlarge image
Instrument DQA Summary Report - RPPS

This report summarizes DQA results by column and by DQA event code. Double-click any of the Report tab cells to drill down to the DQA results for each financial instrument.

Click to enlarge image
Instrument Balance to GL Balance Comparison Report

This report compares the instrument balance to the General Ledger (GL) balance.

NOTE: This report is viewable in both Portable Document Format (PDF) and Excel.

Click to enlarge image
Instrument DQA Summary Report

This report summarizes DQA results by column and by DQA event code. Double-click any cell in the Report tab to drill down to instrument data.

TIP: You can select the prior report period to review that period.

Click to enlarge image

To view validation reports for financial instrument data: 

  1. From the Command Center, click Instrument Data Mart.

  2. Click View Reports.

  3. Under View Validation Reports, in the Report Name column, click the report name to open the report for viewing.

    TIP: The Format column indicates which reports are viewable as PDF files and which are viewable as Excel spreadsheets.